from database.database import engine
from sqlalchemy import text


def select_category_info(id):
    # try:
    with engine.connect() as conn:
        sql = text(f'''
        select * from smart_sales_category where id = :id;
        ''')
        result = conn.execute(sql, [{'id': id}]).fetchone()
    return result
    # except:
    #   pass
